package com.htj.erp.dao;
import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.htj.erp.model.jpa.RouteDis;

/**
 * 
 *
 * RouteDisDao
 * 路程距离 dao 层
 * 使用JPA分页查询 一般继承com.kedacom.security.dao.BaseJpaDao
 *  public Page<PO> findByXXX(String xxx, Pageable pageable);
 * chenghongtao
 * 2016-11-11 11:55:45
 * HTJ
 * @version 1.0.0
 *
 */
@Repository
public interface RouteDisDao extends QualiBaseDao<RouteDis> {
	
	@Query(" from RouteDis where srcLong = :srcLong and srcLat = :srcLat and desLong =:desLong and desLat = :desLat")
	List<RouteDis> findByLongLat(@Param("srcLong")String srcLong, @Param("srcLat")String srcLat,@Param("desLong")String desLong,@Param("desLat")String desLat);
		
}